表操作单据列表
请求地址
/v2/webservice/apply/apply-list
请求参数
| 参数名称 | 类型 | 是否必填 | 说明 | ||||
|---|---|---|---|---|---|---|---|
| id | number | number[] | 否 | 单据ID, 支持传多个单据ID | |||
| app_id | number | 否 | 业务ID | ||||
| zone_id | number[] | 否 | 区ID | ||||
| table_name | string | string[] | 否 | 表名, 支持传多个单据ID | |||
| set_id | number | 否 | 集群ID | ||||
| zone_id_excluded | number[] | 否 | 不包含的区ID | ||||
| execute_user | string | 否 | 申请人 | ||||
| execute_status | -1 | 0 | 1 | 4 | 5 | 否 | 单据状态-1 : 拒绝0 : 待审核1 : 已提交4 : 撤销5 : 系统自动驳回 |
| task_status | 否 | 单据生成的任务的任务状态 | |||||
| apply_type | 否 | 单据类型 | |||||
| create_time_from | 否 | 创建时间开始 | |||||
| create_time_to | 否 | 创建时间结束 | |||||
| current | 否 | 当前页 | |||||
| page_size | 否 | 每页显示 | |||||
| sorter | {column:"字段"，order:"asc"} | 否 | 排序 |
注意 默认30条每页， 可以设置infinite=true返回全部数据
分页 https://iwiki.woa.com/p/4012353821#分页参数说明
排序 https://iwiki.woa.com/p/4012353821#分页参数说明
请求示例
{
"app_id":5,
"id":5
}
返回参数
| 参数名称 | 类型 | 是否必填 | 说明 |
|---|---|---|---|
| list | 对象数组 | 否 | 单据ID |
| 参数名称 | 类型 | 说明 |
|---|---|---|
| app_id | 单据ID | |
| app_name | ||
| apply_type | ||
| attention_man | ||
| audit_memo | 审核意见 | |
| execute_status | 单据状态 -1, // 拒绝 0, // 待审核 1, // 已审核 | |
| execute_user | ||
| id | 单据ID | |
| key_avarage_record_size | ||
| memo | ||
| set_id | 集群ID | |
| set_name | ||
| table_maxnum | ||
| table_name | ||
| table_type | ||
| trans_id | 同task_id | |
| user | ||
| value_avarage_record_size | ||
| write_time | ||
| zone_list | ||
| zone_name | ||
| task_id | 任务ID | |
| task_status | 生成的任务的执行状态, 9表示已完成, 1表示待执行， 4表示执行中，5表示已挂起 10表示异常结束 |
例如
{
"code": 0,
"request_id": "bed50470-9378-40c5-8823-f89795b885af",
"data": {
"list": [
{
"id": 20149,
"kelly_id": 0,
"set_id": 1,
"app_id": 5,
"app_name": "新OMS开发测试",
"zone_list": "555",
"user": "v_demo",
"job_id": "",
"table_name": "GenericTableDemo",
"table_type": 0,
"table_maxnum": 0,
"estimated_volume": 0,
"estimated_avarage_record_size": 0,
"estimated_write_load": 1,
"estimated_read_load": 1,
"type": "tdr",
"key_struct": "",
"value_struct": "",
"write_time": "2023-06-06T02:57:48.000Z",
"memo": "",
"attention_man": "",
"dm_ratio": 5,
"execute_user": "",
"execute_status": 0,
"audit_memo": "",
"task_id": null,
"cu_list": "",
"machine_choose": "",
"version": "",
"hash_mode": 0,
"tdr": "1266",
"apply_type": 0,
"engine_parameters": "",
"key_avarage_record_size": 1,
"value_avarage_record_size": 1,
"compress": 1,
"active_record_num": 1,
"total_record_num": 1,
"trans_id": "",
"calc_resource_type": 1,
"pcu": 0,
"relationship_chain_interval": 0,
"relationship_chain_count": 0,
"index_count": 0,
"read_index_interval": 0,
"read_index_count": 0,
"read_interval": 0,
"write_interval": 0,
"max_read_rate": 0,
"max_write_rate": 0,
"exceed_times": 0,
"idl_md5": null,
"resource_ratio": 1,
"ext_idl_md5": null,
"ext_zone_id": null,
"ext_info": null,
"moa_push_status": 0,
"moa_process_id": "",
"sort_field_num": 0,
"sort_rule": 0,
"data_protocol_type": "TBD",
"censorship": 0,
"censor_status": 0,
"zone_id": "555",
"zone_name": "Z555",
"zone_tag": null,
"task_status": null,
"task_create_time": null,
"set_name": "autoinstall_Set"
}
],
"total": 59
}
}